package com.jyh.dbOrder.entity;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class JyhOrderExample {
    /**
     * jyh_order
     */
    protected String orderByClause;

    /**
     * jyh_order
     */
    protected boolean distinct;

    /**
     * jyh_order
     */
    protected List<Criteria> oredCriteria;

    /**
     *
     * @mbggenerated 2017-10-16
     */
    public JyhOrderExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     *
     * @mbggenerated 2017-10-16
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     *
     * @mbggenerated 2017-10-16
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     *
     * @mbggenerated 2017-10-16
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     *
     * @mbggenerated 2017-10-16
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     *
     * @mbggenerated 2017-10-16
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     *
     * @mbggenerated 2017-10-16
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     *
     * @mbggenerated 2017-10-16
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     *
     * @mbggenerated 2017-10-16
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     *
     * @mbggenerated 2017-10-16
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     *
     * @mbggenerated 2017-10-16
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     * jyh_order 2017-10-16
     */
    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andOrdernoIsNull() {
            addCriterion("orderNO is null");
            return (Criteria) this;
        }

        public Criteria andOrdernoIsNotNull() {
            addCriterion("orderNO is not null");
            return (Criteria) this;
        }

        public Criteria andOrdernoEqualTo(String value) {
            addCriterion("orderNO =", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotEqualTo(String value) {
            addCriterion("orderNO <>", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoGreaterThan(String value) {
            addCriterion("orderNO >", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoGreaterThanOrEqualTo(String value) {
            addCriterion("orderNO >=", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoLessThan(String value) {
            addCriterion("orderNO <", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoLessThanOrEqualTo(String value) {
            addCriterion("orderNO <=", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoLike(String value) {
            addCriterion("orderNO like", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotLike(String value) {
            addCriterion("orderNO not like", value, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoIn(List<String> values) {
            addCriterion("orderNO in", values, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotIn(List<String> values) {
            addCriterion("orderNO not in", values, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoBetween(String value1, String value2) {
            addCriterion("orderNO between", value1, value2, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdernoNotBetween(String value1, String value2) {
            addCriterion("orderNO not between", value1, value2, "orderno");
            return (Criteria) this;
        }

        public Criteria andOrdertimeIsNull() {
            addCriterion("orderTime is null");
            return (Criteria) this;
        }

        public Criteria andOrdertimeIsNotNull() {
            addCriterion("orderTime is not null");
            return (Criteria) this;
        }

        public Criteria andOrdertimeEqualTo(Date value) {
            addCriterion("orderTime =", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeNotEqualTo(Date value) {
            addCriterion("orderTime <>", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeGreaterThan(Date value) {
            addCriterion("orderTime >", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeGreaterThanOrEqualTo(Date value) {
            addCriterion("orderTime >=", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeLessThan(Date value) {
            addCriterion("orderTime <", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeLessThanOrEqualTo(Date value) {
            addCriterion("orderTime <=", value, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeIn(List<Date> values) {
            addCriterion("orderTime in", values, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeNotIn(List<Date> values) {
            addCriterion("orderTime not in", values, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeBetween(Date value1, Date value2) {
            addCriterion("orderTime between", value1, value2, "ordertime");
            return (Criteria) this;
        }

        public Criteria andOrdertimeNotBetween(Date value1, Date value2) {
            addCriterion("orderTime not between", value1, value2, "ordertime");
            return (Criteria) this;
        }

        public Criteria andUsernoIsNull() {
            addCriterion("userNO is null");
            return (Criteria) this;
        }

        public Criteria andUsernoIsNotNull() {
            addCriterion("userNO is not null");
            return (Criteria) this;
        }

        public Criteria andUsernoEqualTo(String value) {
            addCriterion("userNO =", value, "userno");
            return (Criteria) this;
        }

        public Criteria andUsernoNotEqualTo(String value) {
            addCriterion("userNO <>", value, "userno");
            return (Criteria) this;
        }

        public Criteria andUsernoGreaterThan(String value) {
            addCriterion("userNO >", value, "userno");
            return (Criteria) this;
        }

        public Criteria andUsernoGreaterThanOrEqualTo(String value) {
            addCriterion("userNO >=", value, "userno");
            return (Criteria) this;
        }

        public Criteria andUsernoLessThan(String value) {
            addCriterion("userNO <", value, "userno");
            return (Criteria) this;
        }

        public Criteria andUsernoLessThanOrEqualTo(String value) {
            addCriterion("userNO <=", value, "userno");
            return (Criteria) this;
        }

        public Criteria andUsernoLike(String value) {
            addCriterion("userNO like", value, "userno");
            return (Criteria) this;
        }

        public Criteria andUsernoNotLike(String value) {
            addCriterion("userNO not like", value, "userno");
            return (Criteria) this;
        }

        public Criteria andUsernoIn(List<String> values) {
            addCriterion("userNO in", values, "userno");
            return (Criteria) this;
        }

        public Criteria andUsernoNotIn(List<String> values) {
            addCriterion("userNO not in", values, "userno");
            return (Criteria) this;
        }

        public Criteria andUsernoBetween(String value1, String value2) {
            addCriterion("userNO between", value1, value2, "userno");
            return (Criteria) this;
        }

        public Criteria andUsernoNotBetween(String value1, String value2) {
            addCriterion("userNO not between", value1, value2, "userno");
            return (Criteria) this;
        }

        public Criteria andTypenoIsNull() {
            addCriterion("typeNO is null");
            return (Criteria) this;
        }

        public Criteria andTypenoIsNotNull() {
            addCriterion("typeNO is not null");
            return (Criteria) this;
        }

        public Criteria andTypenoEqualTo(String value) {
            addCriterion("typeNO =", value, "typeno");
            return (Criteria) this;
        }

        public Criteria andTypenoNotEqualTo(String value) {
            addCriterion("typeNO <>", value, "typeno");
            return (Criteria) this;
        }

        public Criteria andTypenoGreaterThan(String value) {
            addCriterion("typeNO >", value, "typeno");
            return (Criteria) this;
        }

        public Criteria andTypenoGreaterThanOrEqualTo(String value) {
            addCriterion("typeNO >=", value, "typeno");
            return (Criteria) this;
        }

        public Criteria andTypenoLessThan(String value) {
            addCriterion("typeNO <", value, "typeno");
            return (Criteria) this;
        }

        public Criteria andTypenoLessThanOrEqualTo(String value) {
            addCriterion("typeNO <=", value, "typeno");
            return (Criteria) this;
        }

        public Criteria andTypenoLike(String value) {
            addCriterion("typeNO like", value, "typeno");
            return (Criteria) this;
        }

        public Criteria andTypenoNotLike(String value) {
            addCriterion("typeNO not like", value, "typeno");
            return (Criteria) this;
        }

        public Criteria andTypenoIn(List<String> values) {
            addCriterion("typeNO in", values, "typeno");
            return (Criteria) this;
        }

        public Criteria andTypenoNotIn(List<String> values) {
            addCriterion("typeNO not in", values, "typeno");
            return (Criteria) this;
        }

        public Criteria andTypenoBetween(String value1, String value2) {
            addCriterion("typeNO between", value1, value2, "typeno");
            return (Criteria) this;
        }

        public Criteria andTypenoNotBetween(String value1, String value2) {
            addCriterion("typeNO not between", value1, value2, "typeno");
            return (Criteria) this;
        }

        public Criteria andReviewtimeIsNull() {
            addCriterion("reviewTime is null");
            return (Criteria) this;
        }

        public Criteria andReviewtimeIsNotNull() {
            addCriterion("reviewTime is not null");
            return (Criteria) this;
        }

        public Criteria andReviewtimeEqualTo(Date value) {
            addCriterion("reviewTime =", value, "reviewtime");
            return (Criteria) this;
        }

        public Criteria andReviewtimeNotEqualTo(Date value) {
            addCriterion("reviewTime <>", value, "reviewtime");
            return (Criteria) this;
        }

        public Criteria andReviewtimeGreaterThan(Date value) {
            addCriterion("reviewTime >", value, "reviewtime");
            return (Criteria) this;
        }

        public Criteria andReviewtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("reviewTime >=", value, "reviewtime");
            return (Criteria) this;
        }

        public Criteria andReviewtimeLessThan(Date value) {
            addCriterion("reviewTime <", value, "reviewtime");
            return (Criteria) this;
        }

        public Criteria andReviewtimeLessThanOrEqualTo(Date value) {
            addCriterion("reviewTime <=", value, "reviewtime");
            return (Criteria) this;
        }

        public Criteria andReviewtimeIn(List<Date> values) {
            addCriterion("reviewTime in", values, "reviewtime");
            return (Criteria) this;
        }

        public Criteria andReviewtimeNotIn(List<Date> values) {
            addCriterion("reviewTime not in", values, "reviewtime");
            return (Criteria) this;
        }

        public Criteria andReviewtimeBetween(Date value1, Date value2) {
            addCriterion("reviewTime between", value1, value2, "reviewtime");
            return (Criteria) this;
        }

        public Criteria andReviewtimeNotBetween(Date value1, Date value2) {
            addCriterion("reviewTime not between", value1, value2, "reviewtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeIsNull() {
            addCriterion("endTime is null");
            return (Criteria) this;
        }

        public Criteria andEndtimeIsNotNull() {
            addCriterion("endTime is not null");
            return (Criteria) this;
        }

        public Criteria andEndtimeEqualTo(Date value) {
            addCriterion("endTime =", value, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeNotEqualTo(Date value) {
            addCriterion("endTime <>", value, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeGreaterThan(Date value) {
            addCriterion("endTime >", value, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("endTime >=", value, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeLessThan(Date value) {
            addCriterion("endTime <", value, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeLessThanOrEqualTo(Date value) {
            addCriterion("endTime <=", value, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeIn(List<Date> values) {
            addCriterion("endTime in", values, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeNotIn(List<Date> values) {
            addCriterion("endTime not in", values, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeBetween(Date value1, Date value2) {
            addCriterion("endTime between", value1, value2, "endtime");
            return (Criteria) this;
        }

        public Criteria andEndtimeNotBetween(Date value1, Date value2) {
            addCriterion("endTime not between", value1, value2, "endtime");
            return (Criteria) this;
        }

        public Criteria andPutbanknoIsNull() {
            addCriterion("putBankNO is null");
            return (Criteria) this;
        }

        public Criteria andPutbanknoIsNotNull() {
            addCriterion("putBankNO is not null");
            return (Criteria) this;
        }

        public Criteria andPutbanknoEqualTo(String value) {
            addCriterion("putBankNO =", value, "putbankno");
            return (Criteria) this;
        }

        public Criteria andPutbanknoNotEqualTo(String value) {
            addCriterion("putBankNO <>", value, "putbankno");
            return (Criteria) this;
        }

        public Criteria andPutbanknoGreaterThan(String value) {
            addCriterion("putBankNO >", value, "putbankno");
            return (Criteria) this;
        }

        public Criteria andPutbanknoGreaterThanOrEqualTo(String value) {
            addCriterion("putBankNO >=", value, "putbankno");
            return (Criteria) this;
        }

        public Criteria andPutbanknoLessThan(String value) {
            addCriterion("putBankNO <", value, "putbankno");
            return (Criteria) this;
        }

        public Criteria andPutbanknoLessThanOrEqualTo(String value) {
            addCriterion("putBankNO <=", value, "putbankno");
            return (Criteria) this;
        }

        public Criteria andPutbanknoLike(String value) {
            addCriterion("putBankNO like", value, "putbankno");
            return (Criteria) this;
        }

        public Criteria andPutbanknoNotLike(String value) {
            addCriterion("putBankNO not like", value, "putbankno");
            return (Criteria) this;
        }

        public Criteria andPutbanknoIn(List<String> values) {
            addCriterion("putBankNO in", values, "putbankno");
            return (Criteria) this;
        }

        public Criteria andPutbanknoNotIn(List<String> values) {
            addCriterion("putBankNO not in", values, "putbankno");
            return (Criteria) this;
        }

        public Criteria andPutbanknoBetween(String value1, String value2) {
            addCriterion("putBankNO between", value1, value2, "putbankno");
            return (Criteria) this;
        }

        public Criteria andPutbanknoNotBetween(String value1, String value2) {
            addCriterion("putBankNO not between", value1, value2, "putbankno");
            return (Criteria) this;
        }

        public Criteria andPutbanknameIsNull() {
            addCriterion("putBankName is null");
            return (Criteria) this;
        }

        public Criteria andPutbanknameIsNotNull() {
            addCriterion("putBankName is not null");
            return (Criteria) this;
        }

        public Criteria andPutbanknameEqualTo(String value) {
            addCriterion("putBankName =", value, "putbankname");
            return (Criteria) this;
        }

        public Criteria andPutbanknameNotEqualTo(String value) {
            addCriterion("putBankName <>", value, "putbankname");
            return (Criteria) this;
        }

        public Criteria andPutbanknameGreaterThan(String value) {
            addCriterion("putBankName >", value, "putbankname");
            return (Criteria) this;
        }

        public Criteria andPutbanknameGreaterThanOrEqualTo(String value) {
            addCriterion("putBankName >=", value, "putbankname");
            return (Criteria) this;
        }

        public Criteria andPutbanknameLessThan(String value) {
            addCriterion("putBankName <", value, "putbankname");
            return (Criteria) this;
        }

        public Criteria andPutbanknameLessThanOrEqualTo(String value) {
            addCriterion("putBankName <=", value, "putbankname");
            return (Criteria) this;
        }

        public Criteria andPutbanknameLike(String value) {
            addCriterion("putBankName like", value, "putbankname");
            return (Criteria) this;
        }

        public Criteria andPutbanknameNotLike(String value) {
            addCriterion("putBankName not like", value, "putbankname");
            return (Criteria) this;
        }

        public Criteria andPutbanknameIn(List<String> values) {
            addCriterion("putBankName in", values, "putbankname");
            return (Criteria) this;
        }

        public Criteria andPutbanknameNotIn(List<String> values) {
            addCriterion("putBankName not in", values, "putbankname");
            return (Criteria) this;
        }

        public Criteria andPutbanknameBetween(String value1, String value2) {
            addCriterion("putBankName between", value1, value2, "putbankname");
            return (Criteria) this;
        }

        public Criteria andPutbanknameNotBetween(String value1, String value2) {
            addCriterion("putBankName not between", value1, value2, "putbankname");
            return (Criteria) this;
        }

        public Criteria andPutbankcardIsNull() {
            addCriterion("putBankCard is null");
            return (Criteria) this;
        }

        public Criteria andPutbankcardIsNotNull() {
            addCriterion("putBankCard is not null");
            return (Criteria) this;
        }

        public Criteria andPutbankcardEqualTo(String value) {
            addCriterion("putBankCard =", value, "putbankcard");
            return (Criteria) this;
        }

        public Criteria andPutbankcardNotEqualTo(String value) {
            addCriterion("putBankCard <>", value, "putbankcard");
            return (Criteria) this;
        }

        public Criteria andPutbankcardGreaterThan(String value) {
            addCriterion("putBankCard >", value, "putbankcard");
            return (Criteria) this;
        }

        public Criteria andPutbankcardGreaterThanOrEqualTo(String value) {
            addCriterion("putBankCard >=", value, "putbankcard");
            return (Criteria) this;
        }

        public Criteria andPutbankcardLessThan(String value) {
            addCriterion("putBankCard <", value, "putbankcard");
            return (Criteria) this;
        }

        public Criteria andPutbankcardLessThanOrEqualTo(String value) {
            addCriterion("putBankCard <=", value, "putbankcard");
            return (Criteria) this;
        }

        public Criteria andPutbankcardLike(String value) {
            addCriterion("putBankCard like", value, "putbankcard");
            return (Criteria) this;
        }

        public Criteria andPutbankcardNotLike(String value) {
            addCriterion("putBankCard not like", value, "putbankcard");
            return (Criteria) this;
        }

        public Criteria andPutbankcardIn(List<String> values) {
            addCriterion("putBankCard in", values, "putbankcard");
            return (Criteria) this;
        }

        public Criteria andPutbankcardNotIn(List<String> values) {
            addCriterion("putBankCard not in", values, "putbankcard");
            return (Criteria) this;
        }

        public Criteria andPutbankcardBetween(String value1, String value2) {
            addCriterion("putBankCard between", value1, value2, "putbankcard");
            return (Criteria) this;
        }

        public Criteria andPutbankcardNotBetween(String value1, String value2) {
            addCriterion("putBankCard not between", value1, value2, "putbankcard");
            return (Criteria) this;
        }

        public Criteria andPutstateIsNull() {
            addCriterion("putState is null");
            return (Criteria) this;
        }

        public Criteria andPutstateIsNotNull() {
            addCriterion("putState is not null");
            return (Criteria) this;
        }

        public Criteria andPutstateEqualTo(Integer value) {
            addCriterion("putState =", value, "putstate");
            return (Criteria) this;
        }

        public Criteria andPutstateNotEqualTo(Integer value) {
            addCriterion("putState <>", value, "putstate");
            return (Criteria) this;
        }

        public Criteria andPutstateGreaterThan(Integer value) {
            addCriterion("putState >", value, "putstate");
            return (Criteria) this;
        }

        public Criteria andPutstateGreaterThanOrEqualTo(Integer value) {
            addCriterion("putState >=", value, "putstate");
            return (Criteria) this;
        }

        public Criteria andPutstateLessThan(Integer value) {
            addCriterion("putState <", value, "putstate");
            return (Criteria) this;
        }

        public Criteria andPutstateLessThanOrEqualTo(Integer value) {
            addCriterion("putState <=", value, "putstate");
            return (Criteria) this;
        }

        public Criteria andPutstateIn(List<Integer> values) {
            addCriterion("putState in", values, "putstate");
            return (Criteria) this;
        }

        public Criteria andPutstateNotIn(List<Integer> values) {
            addCriterion("putState not in", values, "putstate");
            return (Criteria) this;
        }

        public Criteria andPutstateBetween(Integer value1, Integer value2) {
            addCriterion("putState between", value1, value2, "putstate");
            return (Criteria) this;
        }

        public Criteria andPutstateNotBetween(Integer value1, Integer value2) {
            addCriterion("putState not between", value1, value2, "putstate");
            return (Criteria) this;
        }

        public Criteria andStateIsNull() {
            addCriterion("state is null");
            return (Criteria) this;
        }

        public Criteria andStateIsNotNull() {
            addCriterion("state is not null");
            return (Criteria) this;
        }

        public Criteria andStateEqualTo(Integer value) {
            addCriterion("state =", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotEqualTo(Integer value) {
            addCriterion("state <>", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThan(Integer value) {
            addCriterion("state >", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThanOrEqualTo(Integer value) {
            addCriterion("state >=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThan(Integer value) {
            addCriterion("state <", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThanOrEqualTo(Integer value) {
            addCriterion("state <=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateIn(List<Integer> values) {
            addCriterion("state in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotIn(List<Integer> values) {
            addCriterion("state not in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateBetween(Integer value1, Integer value2) {
            addCriterion("state between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotBetween(Integer value1, Integer value2) {
            addCriterion("state not between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andScoreIsNull() {
            addCriterion("score is null");
            return (Criteria) this;
        }

        public Criteria andScoreIsNotNull() {
            addCriterion("score is not null");
            return (Criteria) this;
        }

        public Criteria andScoreEqualTo(String value) {
            addCriterion("score =", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreNotEqualTo(String value) {
            addCriterion("score <>", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreGreaterThan(String value) {
            addCriterion("score >", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreGreaterThanOrEqualTo(String value) {
            addCriterion("score >=", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreLessThan(String value) {
            addCriterion("score <", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreLessThanOrEqualTo(String value) {
            addCriterion("score <=", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreLike(String value) {
            addCriterion("score like", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreNotLike(String value) {
            addCriterion("score not like", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreIn(List<String> values) {
            addCriterion("score in", values, "score");
            return (Criteria) this;
        }

        public Criteria andScoreNotIn(List<String> values) {
            addCriterion("score not in", values, "score");
            return (Criteria) this;
        }

        public Criteria andScoreBetween(String value1, String value2) {
            addCriterion("score between", value1, value2, "score");
            return (Criteria) this;
        }

        public Criteria andScoreNotBetween(String value1, String value2) {
            addCriterion("score not between", value1, value2, "score");
            return (Criteria) this;
        }

        public Criteria andOperationtimeIsNull() {
            addCriterion("operationTime is null");
            return (Criteria) this;
        }

        public Criteria andOperationtimeIsNotNull() {
            addCriterion("operationTime is not null");
            return (Criteria) this;
        }

        public Criteria andOperationtimeEqualTo(Date value) {
            addCriterion("operationTime =", value, "operationtime");
            return (Criteria) this;
        }

        public Criteria andOperationtimeNotEqualTo(Date value) {
            addCriterion("operationTime <>", value, "operationtime");
            return (Criteria) this;
        }

        public Criteria andOperationtimeGreaterThan(Date value) {
            addCriterion("operationTime >", value, "operationtime");
            return (Criteria) this;
        }

        public Criteria andOperationtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("operationTime >=", value, "operationtime");
            return (Criteria) this;
        }

        public Criteria andOperationtimeLessThan(Date value) {
            addCriterion("operationTime <", value, "operationtime");
            return (Criteria) this;
        }

        public Criteria andOperationtimeLessThanOrEqualTo(Date value) {
            addCriterion("operationTime <=", value, "operationtime");
            return (Criteria) this;
        }

        public Criteria andOperationtimeIn(List<Date> values) {
            addCriterion("operationTime in", values, "operationtime");
            return (Criteria) this;
        }

        public Criteria andOperationtimeNotIn(List<Date> values) {
            addCriterion("operationTime not in", values, "operationtime");
            return (Criteria) this;
        }

        public Criteria andOperationtimeBetween(Date value1, Date value2) {
            addCriterion("operationTime between", value1, value2, "operationtime");
            return (Criteria) this;
        }

        public Criteria andOperationtimeNotBetween(Date value1, Date value2) {
            addCriterion("operationTime not between", value1, value2, "operationtime");
            return (Criteria) this;
        }

        public Criteria andOperatornameIsNull() {
            addCriterion("operatorName is null");
            return (Criteria) this;
        }

        public Criteria andOperatornameIsNotNull() {
            addCriterion("operatorName is not null");
            return (Criteria) this;
        }

        public Criteria andOperatornameEqualTo(String value) {
            addCriterion("operatorName =", value, "operatorname");
            return (Criteria) this;
        }

        public Criteria andOperatornameNotEqualTo(String value) {
            addCriterion("operatorName <>", value, "operatorname");
            return (Criteria) this;
        }

        public Criteria andOperatornameGreaterThan(String value) {
            addCriterion("operatorName >", value, "operatorname");
            return (Criteria) this;
        }

        public Criteria andOperatornameGreaterThanOrEqualTo(String value) {
            addCriterion("operatorName >=", value, "operatorname");
            return (Criteria) this;
        }

        public Criteria andOperatornameLessThan(String value) {
            addCriterion("operatorName <", value, "operatorname");
            return (Criteria) this;
        }

        public Criteria andOperatornameLessThanOrEqualTo(String value) {
            addCriterion("operatorName <=", value, "operatorname");
            return (Criteria) this;
        }

        public Criteria andOperatornameLike(String value) {
            addCriterion("operatorName like", value, "operatorname");
            return (Criteria) this;
        }

        public Criteria andOperatornameNotLike(String value) {
            addCriterion("operatorName not like", value, "operatorname");
            return (Criteria) this;
        }

        public Criteria andOperatornameIn(List<String> values) {
            addCriterion("operatorName in", values, "operatorname");
            return (Criteria) this;
        }

        public Criteria andOperatornameNotIn(List<String> values) {
            addCriterion("operatorName not in", values, "operatorname");
            return (Criteria) this;
        }

        public Criteria andOperatornameBetween(String value1, String value2) {
            addCriterion("operatorName between", value1, value2, "operatorname");
            return (Criteria) this;
        }

        public Criteria andOperatornameNotBetween(String value1, String value2) {
            addCriterion("operatorName not between", value1, value2, "operatorname");
            return (Criteria) this;
        }

        public Criteria andOperatornoIsNull() {
            addCriterion("operatorNO is null");
            return (Criteria) this;
        }

        public Criteria andOperatornoIsNotNull() {
            addCriterion("operatorNO is not null");
            return (Criteria) this;
        }

        public Criteria andOperatornoEqualTo(String value) {
            addCriterion("operatorNO =", value, "operatorno");
            return (Criteria) this;
        }

        public Criteria andOperatornoNotEqualTo(String value) {
            addCriterion("operatorNO <>", value, "operatorno");
            return (Criteria) this;
        }

        public Criteria andOperatornoGreaterThan(String value) {
            addCriterion("operatorNO >", value, "operatorno");
            return (Criteria) this;
        }

        public Criteria andOperatornoGreaterThanOrEqualTo(String value) {
            addCriterion("operatorNO >=", value, "operatorno");
            return (Criteria) this;
        }

        public Criteria andOperatornoLessThan(String value) {
            addCriterion("operatorNO <", value, "operatorno");
            return (Criteria) this;
        }

        public Criteria andOperatornoLessThanOrEqualTo(String value) {
            addCriterion("operatorNO <=", value, "operatorno");
            return (Criteria) this;
        }

        public Criteria andOperatornoLike(String value) {
            addCriterion("operatorNO like", value, "operatorno");
            return (Criteria) this;
        }

        public Criteria andOperatornoNotLike(String value) {
            addCriterion("operatorNO not like", value, "operatorno");
            return (Criteria) this;
        }

        public Criteria andOperatornoIn(List<String> values) {
            addCriterion("operatorNO in", values, "operatorno");
            return (Criteria) this;
        }

        public Criteria andOperatornoNotIn(List<String> values) {
            addCriterion("operatorNO not in", values, "operatorno");
            return (Criteria) this;
        }

        public Criteria andOperatornoBetween(String value1, String value2) {
            addCriterion("operatorNO between", value1, value2, "operatorno");
            return (Criteria) this;
        }

        public Criteria andOperatornoNotBetween(String value1, String value2) {
            addCriterion("operatorNO not between", value1, value2, "operatorno");
            return (Criteria) this;
        }
    }

    /**
     * jyh_order
     *
     * @mbggenerated do_not_delete_during_merge 2017-10-16
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * jyh_order 2017-10-16
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}